This report analyzes California public school data to explore relationships between socioeconomic factors, teacher salaries, absence rates, and academic performance. The findings reveal several significant correlations that provide insights for educational policy and resource allocation decisions.
Schools with higher percentages of socioeconomically disadvantaged students show significantly lower test scores in both Math and English Language Arts. The correlation values range from -0.76 to -0.84.
Higher teacher salaries show a modest positive correlation with test scores. High-level teacher salaries correlate at approximately 0.18 with test scores, suggesting that competitive compensation may contribute to student achievement.
Higher chronic absence rates strongly correlate with lower test scores. The correlation values range from -0.39 to -0.48, indicating that regular attendance is an important factor in student achievement.
There's a strong correlation (0.72-0.76) between beginning, mid-career, and high-level teacher salaries, suggesting districts with higher starting salaries tend to maintain competitive compensation throughout career progression.
Absence rates strongly correlate across different student groups (0.76-0.95), suggesting that absence issues tend to affect entire school populations rather than being isolated to specific demographic groups.
Figure 1: Relationship between socioeconomic status and math scores showing a strong negative correlation.
Figure 2: Correlation matrix showing relationships between various factors in the dataset.
This reference table explains the variables used in the analysis.
| Variable | Description |
|---|---|
| CDSCODE | Unique identifier for California schools |
| DSAL | District Salary (Normalized) |
| STSAL | State Salary (Normalized) |
| BTCHSAL | Beginning Teacher Salary (Normalized) |
| MTCHSAL | Mid-career Teacher Salary (Normalized) |
| HTCHSAL | High-level Teacher Salary (Normalized) |
| SELA_Y2 | State English Language Arts Test Score |
| SMATH_Y2 | State Mathematics Test Score |
| DELA_Y2 | District English Language Arts Test Score |
| DMATH_Y2 | District Mathematics Test Score |
| PERSD | Percentage of Socioeconomically Disadvantaged Students |
| RALL | Chronic Absence Rate - All Students |
| REL | Chronic Absence Rate - English Learners |
| RSED | Chronic Absence Rate - Socioeconomically Disadvantaged Students |